Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
Please I am trying to write a statement in qlikview as follows:
If month = 'Apr' AND month = 'May' then display these period is spring. But I don't know how to write such a statement in qlikview. Please any help?
Thanks
Hi Sunny,
I have rows with energytypeID 53 and energytypeID 54. 53 means its electricity and 54 gas
Right, but a single row cannot be 53 and 54 at the same time? Can it be?
ID, ElectricityTypeID
10, 53
10, 54
vs.
ID, ElectricityTypeID
10, 53|54
Hi Sunnt
Exactly what you demonstrated in the first table
So is the goal to flag ElectricityTypeID or ID which include both 53 and 54 ElectricityTypeID?
That's correct ! its the goal
On the front end you can use a set analysis in your expression like this:
{<ID = p({<ElectricityTypeID = {53}>})*p({<ElectricityTypeID = {54}>})>}
there are ways to do it in backend also, but for those, I would suggest you to provide a sample of your dataset as the script can change based on how the actual data looks like and I don't want to keep guessing things
Sample:
Script
Table:
LOAD * Inline [
ID, ElectricityTypeID, Consumption
1, 53, 10
1, 54, 13
1, 55, 12
2, 53, 10
2, 52, 9
2, 55, 12
3, 53, 10
3, 54, 13
3, 59, 14
4, 53, 16
5, 53, 11
5, 54, 14
5, 59, 9
];
There are 5 IDs, but I want to display only those IDs where there is ElectricityTypeID of 53 and 54
Hi Sunny,
I want to display but a message if that particular ID has electricitytypeID 53 and 54.
Like this?
Sunny,
Please I can't see the complet expression that is displaying the messages