Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
rt_new_user
Contributor III
Contributor III

Help needed with an expression to visualize data into a line chart

In my line chart i have to use Dimensions as 00 hr, 1 hr, 2 hr, 3hr etc.

Struggling to figure out what expression i use to display on x-axis these hours 00, 1hr, 2hr etc

On Y-Axis i want to display Test_KPI but only when it is equal to  = DownloadRate [KBits/s]

So the expectation is that if i manage to plot this, there will be a distint value for DownloadRate at each hour 

Another complexity is to add the name of the TG Operator this belongs to.

Hope the question is clear.

Thanks for the help in advance!!

 

 

 

Qlikhelp.JPG

1 Solution

Accepted Solutions
kaushiknsolanki

Your load script will be as below.

Crosstable(ColumnName,Value,16)

Load .....,

Avg,

IXP..,

KPI.

 

From xyz;

 

Then remove the KPI,Avg... and unwanted fields from that, which will eventually keep only hours, which is what you need.

 

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

4 Replies
kaushiknsolanki

Hi, You must first convert your crosstable structure to Normal Table using the Crosstab function.

Check more help in below link.

https://help.qlik.com/en-US/sense/September2020/Subsystems/Hub/Content/Sense_Hub/LoadData/work-with-...

Once you do that It will be easy for you to show that information in line chart.

 

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
rt_new_user
Contributor III
Contributor III
Author

Hi Kaushik

Thanks for that great suggestion. I did apply the Crosstable structure and the data looks much more simpler to handle for graphing. 

This is the format of my raw data:

rt_new_user_0-1603369181221.png

 

And this is my Load script:

Crosstable(Hour,KPI_Value,4)

LOAD

KPI as KPI_Name,
Country as Test_Country,
Operator as Test_Operator,

*
FROM
[E:\Qlikview\RT\IPX_SYN2.xlsx]
(ooxml, embedded labels, table is [Sigos Speed Test Pre]);

The output data now looks like the below and very close to what i need, however just take a note of the last 4 values in the Hour table (avg, IPX Routing, KPI and Operator), how do i get rid of these values and only have hours from 00 till 12:

rt_new_user_1-1603369461520.png

 

 

 

kaushiknsolanki

Your load script will be as below.

Crosstable(ColumnName,Value,16)

Load .....,

Avg,

IXP..,

KPI.

 

From xyz;

 

Then remove the KPI,Avg... and unwanted fields from that, which will eventually keep only hours, which is what you need.

 

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
rt_new_user
Contributor III
Contributor III
Author

Thanks Mate

i just had to replace 16 with 8 and it worked like a charm. Thank you.